package com.mapper;
import com.domain.BlogArticle;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface BlogArticleMapper {
    @Select("SELECT * FROM t_article WHERE id=#{id}")
    public BlogArticle selectArticleWithId(Integer id);
    @Insert("INSERT INTO t_article(title,created,modified,tags,categories," +
        " allow_comment,thumbnail,content)" +
        " VALUES (#{title},#{created},#{modified},#{taga},#{categories}," +
        " #{allowComment},#{thumbnail},#{content})")
    @Options(useGeneratedKeys = true,keyProperty = "id",keyColumn = "id")
    public Integer publishArticle(BlogArticle article);
    @Select("SELECT * FROM t_article ORDER BY ID DESC")
    public List<BlogArticle> selectArticleWithPage();

    @Delete("DELETE FROM t_article WHERE id={id}")
    public void  deleteArticleWithId(int id);

    @Select("SELECT COUNT(1) FROM t_article")
    public Integer countArticle();

    @Update("UPDATE t_article SET title=#{title},created=#{created},modified=#{modified},tags=#{tags},thumbnail=#{thumbnail},content=#{content}," +
    "categories=#{categories},hits=#{hits},comments_num=#{commentsNum},allow_comment=#{allowComment} WHERE id={id}")
    public Integer updateArticleWithId(BlogArticle article);
}
